/*
 Navicat Premium Dump SQL

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 80024 (8.0.24)
 Source Host           : localhost:3306
 Source Schema         : English_test_Sys

 Target Server Type    : MySQL
 Target Server Version : 80024 (8.0.24)
 File Encoding         : 65001

 Date: 06/06/2025 10:03:38
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for question
-- ----------------------------
DROP TABLE IF EXISTS `question`;
CREATE TABLE `question` (
  `id` int NOT NULL AUTO_INCREMENT,
  `category` varchar(255) NOT NULL COMMENT '分类',
  `type` varchar(255) NOT NULL COMMENT '题型',
  `difficulty` int NOT NULL DEFAULT '1',
  `content` text NOT NULL COMMENT '题目内容',
  `answer` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '答案\n',
  `analysis` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '解析',
  PRIMARY KEY (`id`),
  KEY `category_id` (`category`),
  KEY `type_id` (`type`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of question
-- ----------------------------
BEGIN;
INSERT INTO `question` (`id`, `category`, `type`, `difficulty`, `content`, `answer`, `analysis`) VALUES (2, 'CET4', 'transation', 1, 'Choose the best word to fill in the blank.', 'B', 'The correct word is \"important\".');
INSERT INTO `question` (`id`, `category`, `type`, `difficulty`, `content`, `answer`, `analysis`) VALUES (5, 'PE', 'transation', 1, 'Select the appropriate word to complete the sentence.', 'D', 'The word \"significantly\" fits best in the context.');
INSERT INTO `question` (`id`, `category`, `type`, `difficulty`, `content`, `answer`, `analysis`) VALUES (8, 'CET6', 'transation', 1, 'Fill in the blank with the most suitable word.', 'B', 'The word \"reduce\" is the correct choice.');
INSERT INTO `question` (`id`, `category`, `type`, `difficulty`, `content`, `answer`, `analysis`) VALUES (21, 'CET4', 'translation', 2, 'Directions:​​ Translate the following Chinese sentences into English.\n中国茶文化历史悠久，可追溯至数千年前。茶不仅是一种饮品，更是中国传统礼仪的重要组成部分。无论是家庭聚会还是商务谈判，茶都扮演着关键角色。近年来，随着健康生活方式的普及，绿茶因其抗氧化功效而备受推崇。', '​​ Chinese tea culture has a long history, dating back thousands of years. Tea is not merely a beverage but also a vital part of traditional Chinese etiquette. Whether at family gatherings or business negotiations, tea plays a pivotal role. In recent years, with the popularity of healthy lifestyles, green tea has been highly valued for its antioxidant properties.', '\"追溯至\"译为\"dating back\"（固定搭配）\n\"重要组成部分\"用\"vital part\"（避免直译\"important component\"）\n\"扮演关键角色\"译为\"plays a pivotal role\"（比\"important\"更地道）\n\"抗氧化功效\"需用专业词汇\"antioxidant properties\"');
INSERT INTO `question` (`id`, `category`, `type`, `difficulty`, `content`, `answer`, `analysis`) VALUES (22, 'CET4', 'writing', 1, 'Directions:​​ Write an essay on the topic: \"Should College Students Take a Gap Year?\" \nYou should write at least 120 words but no more than 180 words.', 'The idea of taking a gap year after high school is increasingly popular, but its value for college students remains debated. Proponents argue that a gap year provides opportunities to gain work experience, travel, or volunteer, which can enhance personal growth and clarify career goals. For example, students interning abroad may develop cross-cultural skills.  However, opponents worry about academic discontinuity and financial costs. A year off might lead to lost momentum in studies, and unpaid internships could burden families.  In my view, a well-planned gap year is beneficial. Universities should offer structured programs to ensure students use the time productively. Ultimately, the decision depends on individual circumstances and goals.', '​​首段​​：引入话题+正方观点（个人成长）\n​​次段​​：反方观点（学业中断、经济压力）\n​​尾段​​：个人立场+建议（学校提供支持）\n\n​​加分点：​​\n举例论证（\"interning abroad\"）\n平衡讨论（\"However\"衔接对立观点）\n提出解决方案（\"structured programs\"）');
INSERT INTO `question` (`id`, `category`, `type`, `difficulty`, `content`, `answer`, `analysis`) VALUES (23, 'CET4', 'reading', 1, 'Passage:​​\nThe sharing economy, represented by companies like Airbnb and Uber, has grown rapidly in the past decade. It allows individuals to rent out their idle resources, such as spare rooms or cars, to others for a fee. Proponents argue that this model promotes sustainability by maximizing resource utilization. However, critics point out its negative impacts, including unfair competition with traditional businesses and lack of regulation. A 2022 study found that in cities with strict Airbnb regulations, hotel revenues rebounded by 15%, suggesting that policy intervention can balance innovation and market fairness.\n\nQuestions:​​\n\nWhat is the main advantage of the sharing economy according to its supporters?\nA) It creates full-time jobs.\nB) It maximizes resource use.\nC) It reduces government control.\nD) It lowers consumer prices.\n\nWhy do critics oppose the sharing economy?\nA) It increases pollution.\nB) It threatens traditional industries.\nC) It requires high investment.\nD) It relies on outdated technology.\n\nWhat did the 2022 study find about strict Airbnb regulations?\nA) They boosted hotel profits.\nB) They discouraged innovation.\nC) They raised rental prices.\nD) They expanded tourism.\n\nThe word \"rebounded\" (Line 6) is closest in meaning to ______.\nA) collapsed\nB) recovered\nC) fluctuated\nD) stabilized\n\nWhat is the author\'s attitude toward the sharing economy?\nA) Strongly critical.\nB) Cautiously optimistic.\nC) Fully supportive.\nD) Indifferent.\n', 'BBABB', '\n​​B​​（依据：\"promotes sustainability by maximizing resource utilization\"）\n​​B​​（依据：\"unfair competition with traditional businesses\"）\n​​A​​（依据：\"hotel revenues rebounded by 15%\"）\n​​B​​（\"rebounded\"指\"恢复\"，同\"recovered\"）\n​​B​​（作者既提到优点也指出问题，态度客观且谨慎');
INSERT INTO `question` (`id`, `category`, `type`, `difficulty`, `content`, `answer`, `analysis`) VALUES (24, 'CET6', 'reading', 1, 'The rapid advancement of artificial intelligence (AI) has triggered widespread concern about its impact on employment. While some economists predict massive job displacement, others argue that AI will create new roles that require advanced skills. A 2023 report by the World Economic Forum estimates that by 2025, AI could eliminate 85 million jobs but generate 97 million new ones, resulting in a net gain. However, the transition may be painful for low-skilled workers, as AI tends to automate routine tasks first. Governments and educational institutions must prioritize reskilling programs to mitigate unemployment risks.\n\n​​Questions:​​\n\nWhat is the main concern about AI’s impact on employment?\nA) It will reduce wages.\nB) It will replace human workers.\nC) It will increase job competition.\nD) It will lower productivity.\nAccording to the WEF report, what is the expected net effect of AI on jobs by 2025?\nA) A loss of 85 million jobs.\nB) A gain of 97 million jobs.\nC) A net increase of 12 million jobs.\nD) No significant change.\nWhich group is most vulnerable to AI-driven job losses?\nA) High-skilled professionals.\nB) Low-skilled workers.\nC) Government employees.\nD) Entrepreneurs.\nWhat does the author suggest to address AI-related unemployment?\nA) Reducing AI development.\nB) Implementing reskilling programs.\nC) Encouraging early retirement.\nD) Increasing manual labor jobs.\nThe word \"mitigate\" (last sentence) is closest in meaning to ______.\nA) eliminate\nB) worsen\nC) reduce\nD) ignore', 'BCBBC', '​​\nB​​（AI 取代人力）\n​​C​​（净增 1200 万岗位）\n​​B​​（低技能工人最受影响）\n​​B​​（再培训计划）\n​​C​​（mitigate = reduce）');
INSERT INTO `question` (`id`, `category`, `type`, `difficulty`, `content`, `answer`, `analysis`) VALUES (25, 'CET6', 'writing', 1, '题目：​​\n​​Directions:​​ Write an essay of ​​150-200 words​​ on the topic: ​​\"Should Universities Offer More Online Courses?\"​​', 'The rise of online education has sparked debate over whether universities should expand their virtual course offerings. Advocates argue that online courses increase accessibility, allowing students in remote areas or with full-time jobs to pursue higher education. Additionally, digital platforms enable flexible learning schedules, which can improve retention rates.  However, critics contend that online education lacks face-to-face interaction, reducing opportunities for discussion and networking. Laboratory-based subjects, such as chemistry or medicine, may also suffer without hands-on training.  In my view, universities should adopt a ​​hybrid model​​, combining online and in-person classes. Core theoretical courses could be delivered online, while practical sessions remain campus-based. This approach balances convenience with academic rigor, ensuring students receive a comprehensive education.', '​​\n结构清晰​​：首段支持观点，次段反对观点，末段个人立场。\n​​使用连接词​​：Additionally, However, In my view（增强逻辑性）。\n​​提出解决方案​​：​​hybrid model​​（体现批判性思维）。');
INSERT INTO `question` (`id`, `category`, `type`, `difficulty`, `content`, `answer`, `analysis`) VALUES (26, 'CET6', 'translation', 2, '题目：​​\n​​Directions:​​ Translate the following Chinese passage into English.\n\n中国近年来在新能源汽车领域取得了显著进展。2022年，中国电动汽车销量占全球总量的60%，成为全球最大的电动汽车市场。政府通过补贴和税收优惠鼓励消费者购买新能源汽车，同时大力建设充电基础设施。专家预测，到2030年，中国新能源汽车的保有量将超过1亿辆，这对减少碳排放具有重要意义。', 'China has made remarkable progress in the new energy vehicle (NEV) sector in recent years. In 2022, China accounted for 60% of global electric vehicle sales, making it the world’s largest EV market. The government encourages consumers to purchase NEVs through subsidies and tax incentives while aggressively expanding charging infrastructure. Experts predict that by 2030, China will have over 100 million NEVs on the road, which will significantly contribute to carbon emission reduction.', '\n“新能源汽车”​​ → ​​\"new energy vehicles (NEVs)\"​​（行业标准译法）\n​​“占全球总量的60%”​​ → ​​\"accounted for 60% of global sales\"​​（避免直译\"occupy\"）\n​​“税收优惠”​​ → ​​\"tax incentives\"​​（固定搭配）\n​​“保有量”​​ → ​​\"on the road\"​​（更符合英文表达）\n');
INSERT INTO `question` (`id`, `category`, `type`, `difficulty`, `content`, `answer`, `analysis`) VALUES (27, 'PE', 'reading', 1, 'The ethical dilemmas posed by artificial intelligence (AI) are becoming increasingly complex. As AI systems make autonomous decisions—from medical diagnoses to criminal sentencing—questions arise about accountability. If a self-driving car causes a fatal accident, who is responsible: the manufacturer, the programmer, or the AI itself? Philosophers argue that AI lacks \"moral agency,\" meaning it cannot be held ethically accountable. Meanwhile, governments struggle to regulate these technologies without stifling innovation. The European Union’s proposed AI Act, which classifies AI applications by risk level, represents a pioneering attempt to balance ethical concerns with technological progress.\n\n​​Questions:​​\n\nWhat is the main ethical issue discussed in the passage?\nA) AI’s impact on employment.\nB) Accountability for AI’s decisions.\nC) The cost of AI development.\nD) Public distrust of AI.\nAccording to philosophers, why can’t AI be ethically accountable?\nA) It is too expensive to regulate.\nB) It lacks moral agency.\nC) It follows human instructions.\nD) It is not widely adopted yet.\nWhat is the purpose of the EU’s AI Act?\nA) To ban high-risk AI applications.\nB) To encourage unlimited AI innovation.\nC) To balance ethics and technological growth.\nD) To transfer liability to AI systems.\nThe word \"stifling\" (Line 6) is closest in meaning to ______.\nA) promoting\nB) restricting\nC) ignoring\nD) rewarding\nWhich of the following best summarizes the author’s tone?\nA) Optimistic about AI’s future.\nB) Critical of government inaction.\nC) Concerned but pragmatic.\nD) Dismissive of ethical debates.\n', 'BBCBC', '\nB​​（AI 决策的责任归属）\n​​B​​（缺乏道德主体性）\n​​C​​（伦理与技术的平衡）\n​​B​​（stifling = 限制）\n​​C​​（关切但务实）');
INSERT INTO `question` (`id`, `category`, `type`, `difficulty`, `content`, `answer`, `analysis`) VALUES (28, 'PE', 'reading', 2, 'Historical fiction occupies a unique space between fact and imagination. Novels like Hilary Mantel’s Wolf Hall reconstruct the past with meticulous detail, yet their narratives inevitably reflect contemporary perspectives. Critics debate whether such works distort history or illuminate its hidden complexities. For instance, Mantel’s portrayal of Thomas Cromwell challenges traditional Tudor-era narratives by humanizing a figure often vilified in textbooks. This tension between artistic license and historical accuracy raises broader questions: Can fiction ever be \"true\" to the past? Or is its value precisely in its ability to reinterpret history through a modern lens?\n\n​​Questions:​​\n6. What is the central debate about historical fiction?\nA) Its popularity compared to nonfiction.\nB) Its balance of fact and creative interpretation.\nC) Its reliance on primary sources.\nD) Its influence on academic historians.\n\nHow does Wolf Hall differ from traditional accounts of Thomas Cromwell?\nA) It portrays him as a villain.\nB) It offers a more sympathetic view.\nC) It ignores his political role.\nD) It exaggerates his achievements.\nThe phrase \"artistic license\" (Line 5) refers to ______.\nA) strict adherence to facts\nB) freedom to alter details for creative purposes\nC) legal rights to publish historical works\nD) criticism of inaccurate portrayals\nWhat question does the passage leave unresolved?\nA) Whether historical fiction should be banned.\nB) Whether fiction can objectively represent history.\nC) Whether Hilary Mantel is a reliable author.\nD) Whether Tudor history is well-documented.\nThe author’s attitude toward historical fiction is ______.\nA) openly hostile\nB) neutrally analytical\nC) enthusiastically supportive\nD) sarcastically dismissive\n', 'BBBBB', '\nB​​（事实与虚构的平衡）\n​​B​​（更同情的视角）\n​​B​​（艺术创作的自由）\n​​B​​（小说能否客观呈现历史）\n​​B​​（中立分析）\n');
INSERT INTO `question` (`id`, `category`, `type`, `difficulty`, `content`, `answer`, `analysis`) VALUES (29, 'PE', 'writing', 1, 'Directions:​​\n\nStudy the following chart (假设图表显示2000-2023年全球电子书与纸质书销量变化) and write an essay of ​​160-200 words​​.\nYour essay should:\nDescribe the chart;\nAnalyze possible reasons;\nPredict future trends.', 'The Decline of Print Books: A Digital Revolution?​​ The chart reveals a dramatic shift in reading habits over two decades. In 2000, print books dominated 95% of the market, but by 2023, their share plummeted to 40%, while e-books surged to 60%.  Three factors drive this trend. First, ​​digital convenience​​—e-books are portable and instantly accessible. Second, ​​environmental concerns​​—many readers prefer paperless options to reduce deforestation. Third, ​​pricing​​—e-books are often cheaper due to lower production costs.  Looking ahead, print books may stabilize as niche markets (e.g., collectors, children’s books) persist. However, e-books will likely dominate, especially with advancements in e-ink technology and interactive features. Ultimately, this shift reflects broader societal adaptation to the digital age.', '\n描述数据​​：用对比词汇（dominated, plummeted, surged）。\n​​分析原因​​：分点论述，结合社会背景。\n​​预测趋势​​：避免绝对化（may, likely）。\n');
INSERT INTO `question` (`id`, `category`, `type`, `difficulty`, `content`, `answer`, `analysis`) VALUES (30, 'PE', 'translation', 2, '题目：​​\n​​Directions:​​ Translate the underlined sentences into Chinese.\n\nThe concept of \"degrowth\" challenges the traditional economic paradigm that equates progress with GDP growth. Advocates argue that infinite expansion on a finite planet is unsustainable and call for redistributing resources to prioritize well-being over productivity. (1) ​​This movement emphasizes reducing consumption in wealthy nations while ensuring basic needs are met globally.​​ Critics, however, contend that degrowth would stall technological advancement and exacerbate poverty. (2) ​​Yet, evidence from countries like Costa Rica shows that prioritizing ecological balance over unchecked growth can improve life satisfaction without sacrificing economic stability.​​', '该运动强调减少富裕国家的消费，同时确保全球基本需求得到满足。​​ （关键词：emphasizes reducing consumption → \"强调减少消费\"；basic needs → \"基本需求\"） ​​然而，哥斯达黎加等国的例子表明，将生态平衡置于无节制增长之上，可在不牺牲经济稳定的情况下提升生活满意度。​​ （句型调整：evidence...shows that... → \"例子表明\"；life satisfaction → \"生活满意度\"）', '\n被动语态​​（are met）→ 中文主动表达（\"得到满足\"）。\n​​长句拆分​​（第二句）→ 中文多用短句。\n');
INSERT INTO `question` (`id`, `category`, `type`, `difficulty`, `content`, `answer`, `analysis`) VALUES (32, 'CET4', 'translation', 4, 'A few years ago, I was stuck in a cycle of procrastination. I wanted to write a book, get fit, and learn a new language—but I kept waiting for the ‘perfect moment.’ Then I discovered something revolutionary: ​​tiny habits​​. Not grand resolutions, but small, consistent actions. Today, I’ve published that book, run marathons, and even speak Spanish—all because of habits so small they seemed trivial at first.\"', '几年前，我深陷拖延症的泥潭。我想写一本书、健身、学一门新语言——却一直在等待“完美时机”。直到后来，我发现了某种颠覆性的方法：微习惯。不是宏大的目标，而是微小却持之以恒的行动。如今，我出版了那本书、跑完了马拉松，甚至能说一口流利的西班牙语——一切都源于那些起初看似微不足道的习惯。    （注：根据 TED 演讲风格，翻译时保留了口语化的感染力，如“泥潭”“颠覆性”等比喻，同时将“tiny habits”译为“微习惯”以贴合中文习惯说法。关键句如“不是...而是...”的对比结构也还原了原文的节奏感。）', 'easy');
INSERT INTO `question` (`id`, `category`, `type`, `difficulty`, `content`, `answer`, `analysis`) VALUES (33, 'CET4', 'reading', 1, 'The rise of artificial intelligence (AI) has sparked debates about its impact on jobs. While some fear massive unemployment, others argue AI will create new roles. A 2023 report by the World Economic Forum predicts that by 2025, AI may replace 85 million jobs globally but generate 97 million new ones, requiring skills like data analysis and machine learning.\n\n​​Questions:​​\n\nWhat is the main argument of the report mentioned in the passage?\nA) AI will cause permanent unemployment.\nB) AI will replace more jobs than it creates.\n​​C) AI may create more jobs than it eliminates.​​\nD) AI requires no human intervention.\n\nThe word \"sparked\" in the first sentence is closest in meaning to _____.\nA) extinguished\n​​B) triggered​​\nC) ignored\nD) simplified\n\nWhat kind of skills will be needed for future jobs according to the passage?\nA) Manual labor.\nB) Traditional manufacturing.\n​​C) Data analysis and machine learning.​​\nD) Basic computer operation.', 'CBC', '原文重点​​：AI可能取代8500万工作，但创造9700万新岗位，需要数据分析等技能。\n\n​​What is the main argument of the report?​​\n​​答案：C) AI may create more jobs than it eliminates.​​\n​​解析​​：原文明确对比数据（97 million新岗位 > 85 million被取代），C是直接概括。A与原文矛盾，B反向，D未提及。\n​​The word \"sparked\" is closest in meaning to _____.​​\n​​答案：B) triggered​​\n​​解析​​：上下文指AI“引发”争论，triggered（触发）最接近。A（熄灭）、C（忽略）、D（简化）不符。\n​​What skills will be needed for future jobs?​​\n​​答案：C) Data analysis and machine learning.​​\n​​解析​​：原文明确提到新岗位需要这些技能（requiring skills like...），其他选项未提及或与原文无关。');
INSERT INTO `question` (`id`, `category`, `type`, `difficulty`, `content`, `answer`, `analysis`) VALUES (34, 'CET4', 'reading', 1, 'Online learning has become increasingly popular, especially after the COVID-19 pandemic. A study by Harvard University found that 70% of students felt online courses offered flexibility, but 30% struggled with self-discipline. Experts suggest combining online and in-person methods (\"hybrid learning\") to maximize benefits.\n\nQuestions:​​\n4. What percentage of students in the study found online learning flexible?\n​​A) 70%​​\nB) 50%\nC) 30%\nD) 20%\n\nWhat is the main challenge some students face with online learning?\nA) High costs.\n​​B) Lack of self-discipline.​​\nC) Limited course options.\nD) Technical difficulties.\n\nWhat solution do experts recommend for improving online education?\nA) Abandoning traditional classrooms.\n​​B) Combining online and in-person methods.​​\nC) Reducing course durations.\nD) Focusing only on recorded lectures.', 'ABB', '原文重点​​：70%学生认为网课灵活，30%缺乏自律；专家建议混合教学。\n\n​​What percentage found online learning flexible?​​\n​​答案：A) 70%​​\n​​解析​​：直接细节题，原文数据明确。\n​​What is the main challenge for some students?​​\n​​答案：B) Lack of self-discipline.​​\n​​解析​​：30%学生的问题原文直接指出（struggled with self-discipline），其他选项未提及。\n​​What solution do experts recommend?​​\n​​答案：B) Combining online and in-person methods.​​\n​​解析​​：专家建议hybrid learning（混合教学），B是同义替换。A（放弃线下）与建议相反，C、D无关。');
COMMIT;

-- ----------------------------
-- Table structure for user_word_records
-- ----------------------------
DROP TABLE IF EXISTS `user_word_records`;
CREATE TABLE `user_word_records` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `word_id` int NOT NULL,
  `review_count` int DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `word_id` (`word_id`),
  CONSTRAINT `user_word_records_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  CONSTRAINT `user_word_records_ibfk_2` FOREIGN KEY (`word_id`) REFERENCES `words` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of user_word_records
-- ----------------------------
BEGIN;
INSERT INTO `user_word_records` (`id`, `user_id`, `word_id`, `review_count`) VALUES (5, 10, 39, 1);
INSERT INTO `user_word_records` (`id`, `user_id`, `word_id`, `review_count`) VALUES (6, 10, 37, 1);
INSERT INTO `user_word_records` (`id`, `user_id`, `word_id`, `review_count`) VALUES (7, 10, 33, 1);
INSERT INTO `user_word_records` (`id`, `user_id`, `word_id`, `review_count`) VALUES (8, 10, 38, 1);
INSERT INTO `user_word_records` (`id`, `user_id`, `word_id`, `review_count`) VALUES (9, 10, 41, 1);
INSERT INTO `user_word_records` (`id`, `user_id`, `word_id`, `review_count`) VALUES (10, 10, 49, 1);
INSERT INTO `user_word_records` (`id`, `user_id`, `word_id`, `review_count`) VALUES (11, 10, 45, 1);
INSERT INTO `user_word_records` (`id`, `user_id`, `word_id`, `review_count`) VALUES (12, 10, 47, 1);
INSERT INTO `user_word_records` (`id`, `user_id`, `word_id`, `review_count`) VALUES (13, 10, 50, 1);
INSERT INTO `user_word_records` (`id`, `user_id`, `word_id`, `review_count`) VALUES (14, 10, 11, 1);
INSERT INTO `user_word_records` (`id`, `user_id`, `word_id`, `review_count`) VALUES (15, 10, 21, 1);
INSERT INTO `user_word_records` (`id`, `user_id`, `word_id`, `review_count`) VALUES (16, 10, 24, 2);
INSERT INTO `user_word_records` (`id`, `user_id`, `word_id`, `review_count`) VALUES (17, 10, 14, 2);
INSERT INTO `user_word_records` (`id`, `user_id`, `word_id`, `review_count`) VALUES (18, 10, 30, 1);
INSERT INTO `user_word_records` (`id`, `user_id`, `word_id`, `review_count`) VALUES (19, 10, 13, 1);
INSERT INTO `user_word_records` (`id`, `user_id`, `word_id`, `review_count`) VALUES (20, 10, 19, 2);
INSERT INTO `user_word_records` (`id`, `user_id`, `word_id`, `review_count`) VALUES (21, 10, 12, 1);
INSERT INTO `user_word_records` (`id`, `user_id`, `word_id`, `review_count`) VALUES (22, 2, 18, 1);
INSERT INTO `user_word_records` (`id`, `user_id`, `word_id`, `review_count`) VALUES (23, 10, 18, 1);
INSERT INTO `user_word_records` (`id`, `user_id`, `word_id`, `review_count`) VALUES (24, 10, 15, 1);
INSERT INTO `user_word_records` (`id`, `user_id`, `word_id`, `review_count`) VALUES (25, 10, 16, 1);
INSERT INTO `user_word_records` (`id`, `user_id`, `word_id`, `review_count`) VALUES (26, 10, 29, 1);
INSERT INTO `user_word_records` (`id`, `user_id`, `word_id`, `review_count`) VALUES (27, 10, 27, 1);
COMMIT;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `password` varchar(100) NOT NULL,
  `email` varchar(100) DEFAULT NULL,
  `user_type` enum('student','admin') DEFAULT 'student',
  `score` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of users
-- ----------------------------
BEGIN;
INSERT INTO `users` (`id`, `username`, `password`, `email`, `user_type`, `score`) VALUES (1, '谢飞', '123', '1', 'student', 50);
INSERT INTO `users` (`id`, `username`, `password`, `email`, `user_type`, `score`) VALUES (2, '1', '1', '1@qq.com', 'student', 100);
INSERT INTO `users` (`id`, `username`, `password`, `email`, `user_type`, `score`) VALUES (3, 'Admin', '12345', NULL, 'admin', NULL);
INSERT INTO `users` (`id`, `username`, `password`, `email`, `user_type`, `score`) VALUES (6, '2', '22', '222@11.com', 'student', 10);
INSERT INTO `users` (`id`, `username`, `password`, `email`, `user_type`, `score`) VALUES (9, '9', '9', NULL, 'student', 60);
INSERT INTO `users` (`id`, `username`, `password`, `email`, `user_type`, `score`) VALUES (10, 'MelloW', '123', '1320976489@qq.com', 'student', 60);
COMMIT;

-- ----------------------------
-- Table structure for word_categories
-- ----------------------------
DROP TABLE IF EXISTS `word_categories`;
CREATE TABLE `word_categories` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL COMMENT '如CET4/CET6/考研/雅思等',
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of word_categories
-- ----------------------------
BEGIN;
INSERT INTO `word_categories` (`id`, `name`, `description`) VALUES (1, 'CET4', '大学英语四级词汇');
INSERT INTO `word_categories` (`id`, `name`, `description`) VALUES (2, 'CET6', '大学英语六级词汇');
INSERT INTO `word_categories` (`id`, `name`, `description`) VALUES (3, '考研', '研究生入学考试词汇');
INSERT INTO `word_categories` (`id`, `name`, `description`) VALUES (4, '雅思', '雅思考试词汇');
COMMIT;

-- ----------------------------
-- Table structure for words
-- ----------------------------
DROP TABLE IF EXISTS `words`;
CREATE TABLE `words` (
  `id` int NOT NULL AUTO_INCREMENT,
  `category_id` int NOT NULL,
  `english` varchar(100) NOT NULL,
  `chinese` varchar(100) NOT NULL,
  `part_of_speech` varchar(20) DEFAULT NULL,
  `example_sentence` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `category_id` (`category_id`),
  CONSTRAINT `words_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `word_categories` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of words
-- ----------------------------
BEGIN;
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (11, 1, 'abandon', '抛弃', 'v', 'Never abandon your dreams.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (12, 1, 'benefit', '利益', 'n', 'Exercise brings great benefit.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (13, 1, 'challenge', '挑战', 'n', 'He accepted the challenge bravely.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (14, 1, 'delicate', '精致的', 'adj', 'Handle the delicate vase carefully.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (15, 1, 'essential', '必要的', 'adj', 'Water is essential for life.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (16, 1, 'frequent', '频繁的', 'adj', 'He makes frequent visits.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (17, 1, 'generous', '慷慨的', 'adj', 'She is generous with her time.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (18, 1, 'humble', '谦逊的', 'adj', 'Stay humble and keep learning.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (19, 1, 'illustrate', '说明', 'v', 'The diagram illustrates the process.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (20, 1, 'jealous', '嫉妒的', 'adj', 'Don\'t be jealous of others.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (21, 2, 'ambiguous', '模糊的', 'adj', 'His answer was ambiguous.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (22, 2, 'benevolent', '仁慈的', 'adj', 'The benevolent man donated money.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (23, 2, 'cognitive', '认知的', 'adj', 'Cognitive abilities develop with age.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (24, 2, 'deteriorate', '恶化', 'v', 'The weather may deteriorate.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (25, 2, 'eloquent', '雄辩的', 'adj', 'She gave an eloquent speech.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (26, 2, 'formidable', '强大的', 'adj', 'They faced formidable opponents.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (27, 2, 'gregarious', '社交的', 'adj', 'Dolphins are gregarious animals.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (28, 2, 'hypothesis', '假设', 'n', 'This hypothesis needs testing.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (29, 2, 'indigenous', '本土的', 'adj', 'Protect indigenous cultures.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (30, 2, 'juxtapose', '并列', 'v', 'The exhibition juxtaposes old and new.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (31, 3, 'allegation', '指控', 'n', 'The allegation proved false.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (32, 3, 'bureaucracy', '官僚主义', 'n', 'The bureaucracy slows decisions.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (33, 3, 'contingency', '偶然性', 'n', 'Prepare for all contingencies.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (34, 3, 'depreciate', '贬值', 'v', 'The currency may depreciate.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (35, 3, 'empirical', '经验主义的', 'adj', 'Empirical evidence supports this.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (36, 3, 'fluctuate', '波动', 'v', 'Prices fluctuate daily.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (37, 3, 'heterogeneous', '异质的', 'adj', 'The group was heterogeneous.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (38, 3, 'integrity', '正直', 'n', 'He is a man of integrity.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (39, 3, 'jurisdiction', '管辖权', 'n', 'This is under federal jurisdiction.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (40, 3, 'kinetic', '运动的', 'adj', 'Kinetic energy increases with speed.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (41, 4, 'biodiversity', '生物多样性', 'n', 'Protect rainforest biodiversity.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (42, 4, 'carbon-neutral', '碳中和的', 'adj', 'The company aims to be carbon-neutral.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (43, 4, 'demography', '人口统计', 'n', 'Demography studies population trends.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (44, 4, 'ecosystem', '生态系统', 'n', 'Coral reefs are fragile ecosystems.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (45, 4, 'fossil fuel', '化石燃料', 'n', 'Reduce fossil fuel consumption.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (46, 4, 'greenhouse', '温室', 'n', 'Greenhouse gases cause warming.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (47, 4, 'habitat', '栖息地', 'n', 'Urbanization destroys natural habitats.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (48, 4, 'infrastructure', '基础设施', 'n', 'Improve transportation infrastructure.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (49, 4, 'sustainable', '可持续的', 'adj', 'We need sustainable solutions.');
INSERT INTO `words` (`id`, `category_id`, `english`, `chinese`, `part_of_speech`, `example_sentence`) VALUES (50, 4, 'urbanization', '城市化', 'n', 'Rapid urbanization causes problems.');
COMMIT;

-- ----------------------------
-- Table structure for wrong_question
-- ----------------------------
DROP TABLE IF EXISTS `wrong_question`;
CREATE TABLE `wrong_question` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL COMMENT '关联用户ID',
  `question_id` int NOT NULL COMMENT '关联题目ID',
  `category` varchar(10) NOT NULL COMMENT '考试类别(CET4/CET6/PE)',
  `type` varchar(20) NOT NULL COMMENT '题目类型(reading/writing/translation)',
  `question_content` text NOT NULL COMMENT '题目内容',
  `user_answer` text COMMENT '用户错误答案',
  `correct_answer` text NOT NULL COMMENT '正确答案',
  `analysis` text COMMENT '题目解析',
  `wrong_count` int DEFAULT '1' COMMENT '错误次数',
  `notes` text COMMENT '用户笔记',
  `score_impact` int DEFAULT '-5' COMMENT '分数影响值',
  PRIMARY KEY (`id`),
  KEY `question_id` (`question_id`),
  KEY `idx_user_question` (`user_id`,`question_id`),
  KEY `idx_category_type` (`category`,`type`),
  CONSTRAINT `wrong_question_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  CONSTRAINT `wrong_question_ibfk_2` FOREIGN KEY (`question_id`) REFERENCES `question` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户错题记录表';

-- ----------------------------
-- Records of wrong_question
-- ----------------------------
BEGIN;
INSERT INTO `wrong_question` (`id`, `user_id`, `question_id`, `category`, `type`, `question_content`, `user_answer`, `correct_answer`, `analysis`, `wrong_count`, `notes`, `score_impact`) VALUES (1, 10, 23, 'CET4', 'reading', 'Passage:​​\nThe sharing economy, represented by companies like Airbnb and Uber, has grown rapidly in the past decade. It allows individuals to rent out their idle resources, such as spare rooms or cars, to others for a fee. Proponents argue that this model promotes sustainability by maximizing resource utilization. However, critics point out its negative impacts, including unfair competition with traditional businesses and lack of regulation. A 2022 study found that in cities with strict Airbnb regulations, hotel revenues rebounded by 15%, suggesting that policy intervention can balance innovation and market fairness.\n\nQuestions:​​\n\nWhat is the main advantage of the sharing economy according to its supporters?\nA) It creates full-time jobs.\nB) It maximizes resource use.\nC) It reduces government control.\nD) It lowers consumer prices.\n\nWhy do critics oppose the sharing economy?\nA) It increases pollution.\nB) It threatens traditional industries.\nC) It requires high investment.\nD) It relies on outdated technology.\n\nWhat did the 2022 study find about strict Airbnb regulations?\nA) They boosted hotel profits.\nB) They discouraged innovation.\nC) They raised rental prices.\nD) They expanded tourism.\n\nThe word \"rebounded\" (Line 6) is closest in meaning to ______.\nA) collapsed\nB) recovered\nC) fluctuated\nD) stabilized\n\nWhat is the author\'s attitude toward the sharing economy?\nA) Strongly critical.\nB) Cautiously optimistic.\nC) Fully supportive.\nD) Indifferent.\n', 'BBBBB', 'BBABB', '\n​​B​​（依据：\"promotes sustainability by maximizing resource utilization\"）\n​​B​​（依据：\"unfair competition with traditional businesses\"）\n​​A​​（依据：\"hotel revenues rebounded by 15%\"）\n​​B​​（\"rebounded\"指\"恢复\"，同\"recovered\"）\n​​B​​（作者既提到优点也指出问题，态度客观且谨慎', 6, '111', -5);
INSERT INTO `wrong_question` (`id`, `user_id`, `question_id`, `category`, `type`, `question_content`, `user_answer`, `correct_answer`, `analysis`, `wrong_count`, `notes`, `score_impact`) VALUES (5, 10, 33, 'CET4', 'reading', 'The rise of artificial intelligence (AI) has sparked debates about its impact on jobs. While some fear massive unemployment, others argue AI will create new roles. A 2023 report by the World Economic Forum predicts that by 2025, AI may replace 85 million jobs globally but generate 97 million new ones, requiring skills like data analysis and machine learning.\n\n​​Questions:​​\n\nWhat is the main argument of the report mentioned in the passage?\nA) AI will cause permanent unemployment.\nB) AI will replace more jobs than it creates.\n​​C) AI may create more jobs than it eliminates.​​\nD) AI requires no human intervention.\n\nThe word \"sparked\" in the first sentence is closest in meaning to _____.\nA) extinguished\n​​B) triggered​​\nC) ignored\nD) simplified\n\nWhat kind of skills will be needed for future jobs according to the passage?\nA) Manual labor.\nB) Traditional manufacturing.\n​​C) Data analysis and machine learning.​​\nD) Basic computer operation.', 'BBBBB', 'CBC', '原文重点​​：AI可能取代8500万工作，但创造9700万新岗位，需要数据分析等技能。\n\n​​What is the main argument of the report?​​\n​​答案：C) AI may create more jobs than it eliminates.​​\n​​解析​​：原文明确对比数据（97 million新岗位 > 85 million被取代），C是直接概括。A与原文矛盾，B反向，D未提及。\n​​The word \"sparked\" is closest in meaning to _____.​​\n​​答案：B) triggered​​\n​​解析​​：上下文指AI“引发”争论，triggered（触发）最接近。A（熄灭）、C（忽略）、D（简化）不符。\n​​What skills will be needed for future jobs?​​\n​​答案：C) Data analysis and machine learning.​​\n​​解析​​：原文明确提到新岗位需要这些技能（requiring skills like...），其他选项未提及或与原文无关。', 5, NULL, -5);
INSERT INTO `wrong_question` (`id`, `user_id`, `question_id`, `category`, `type`, `question_content`, `user_answer`, `correct_answer`, `analysis`, `wrong_count`, `notes`, `score_impact`) VALUES (6, 10, 34, 'CET4', 'reading', 'Online learning has become increasingly popular, especially after the COVID-19 pandemic. A study by Harvard University found that 70% of students felt online courses offered flexibility, but 30% struggled with self-discipline. Experts suggest combining online and in-person methods (\"hybrid learning\") to maximize benefits.\n\nQuestions:​​\n4. What percentage of students in the study found online learning flexible?\n​​A) 70%​​\nB) 50%\nC) 30%\nD) 20%\n\nWhat is the main challenge some students face with online learning?\nA) High costs.\n​​B) Lack of self-discipline.​​\nC) Limited course options.\nD) Technical difficulties.\n\nWhat solution do experts recommend for improving online education?\nA) Abandoning traditional classrooms.\n​​B) Combining online and in-person methods.​​\nC) Reducing course durations.\nD) Focusing only on recorded lectures.', 'BBBBB', 'ABB', '原文重点​​：70%学生认为网课灵活，30%缺乏自律；专家建议混合教学。\n\n​​What percentage found online learning flexible?​​\n​​答案：A) 70%​​\n​​解析​​：直接细节题，原文数据明确。\n​​What is the main challenge for some students?​​\n​​答案：B) Lack of self-discipline.​​\n​​解析​​：30%学生的问题原文直接指出（struggled with self-discipline），其他选项未提及。\n​​What solution do experts recommend?​​\n​​答案：B) Combining online and in-person methods.​​\n​​解析​​：专家建议hybrid learning（混合教学），B是同义替换。A（放弃线下）与建议相反，C、D无关。', 4, NULL, -5);
INSERT INTO `wrong_question` (`id`, `user_id`, `question_id`, `category`, `type`, `question_content`, `user_answer`, `correct_answer`, `analysis`, `wrong_count`, `notes`, `score_impact`) VALUES (7, 10, 25, 'CET6', 'writing', '题目：​​\n​​Directions:​​ Write an essay of ​​150-200 words​​ on the topic: ​​\"Should Universities Offer More Online Courses?\"​​', '1', 'The rise of online education has sparked debate over whether universities should expand their virtual course offerings. Advocates argue that online courses increase accessibility, allowing students in remote areas or with full-time jobs to pursue higher education. Additionally, digital platforms enable flexible learning schedules, which can improve retention rates.  However, critics contend that online education lacks face-to-face interaction, reducing opportunities for discussion and networking. Laboratory-based subjects, such as chemistry or medicine, may also suffer without hands-on training.  In my view, universities should adopt a ​​hybrid model​​, combining online and in-person classes. Core theoretical courses could be delivered online, while practical sessions remain campus-based. This approach balances convenience with academic rigor, ensuring students receive a comprehensive education.', '​​\n结构清晰​​：首段支持观点，次段反对观点，末段个人立场。\n​​使用连接词​​：Additionally, However, In my view（增强逻辑性）。\n​​提出解决方案​​：​​hybrid model​​（体现批判性思维）。', 3, NULL, -5);
INSERT INTO `wrong_question` (`id`, `user_id`, `question_id`, `category`, `type`, `question_content`, `user_answer`, `correct_answer`, `analysis`, `wrong_count`, `notes`, `score_impact`) VALUES (8, 10, 30, 'PE', 'translation', '题目：​​\n​​Directions:​​ Translate the underlined sentences into Chinese.\n\nThe concept of \"degrowth\" challenges the traditional economic paradigm that equates progress with GDP growth. Advocates argue that infinite expansion on a finite planet is unsustainable and call for redistributing resources to prioritize well-being over productivity. (1) ​​This movement emphasizes reducing consumption in wealthy nations while ensuring basic needs are met globally.​​ Critics, however, contend that degrowth would stall technological advancement and exacerbate poverty. (2) ​​Yet, evidence from countries like Costa Rica shows that prioritizing ecological balance over unchecked growth can improve life satisfaction without sacrificing economic stability.​​', '巴拉巴拉哔哩哔哩巴拉巴拉巴拉巴拉巴拉巴拉吧', '该运动强调减少富裕国家的消费，同时确保全球基本需求得到满足。​​ （关键词：emphasizes reducing consumption → \"强调减少消费\"；basic needs → \"基本需求\"） ​​然而，哥斯达黎加等国的例子表明，将生态平衡置于无节制增长之上，可在不牺牲经济稳定的情况下提升生活满意度。​​ （句型调整：evidence...shows that... → \"例子表明\"；life satisfaction → \"生活满意度\"）', '\n被动语态​​（are met）→ 中文主动表达（\"得到满足\"）。\n​​长句拆分​​（第二句）→ 中文多用短句。\n', 1, NULL, -5);
INSERT INTO `wrong_question` (`id`, `user_id`, `question_id`, `category`, `type`, `question_content`, `user_answer`, `correct_answer`, `analysis`, `wrong_count`, `notes`, `score_impact`) VALUES (9, 2, 29, 'PE', 'writing', 'Directions:​​\n\nStudy the following chart (假设图表显示2000-2023年全球电子书与纸质书销量变化) and write an essay of ​​160-200 words​​.\nYour essay should:\nDescribe the chart;\nAnalyze possible reasons;\nPredict future trends.', 'asdaddads', 'The Decline of Print Books: A Digital Revolution?​​ The chart reveals a dramatic shift in reading habits over two decades. In 2000, print books dominated 95% of the market, but by 2023, their share plummeted to 40%, while e-books surged to 60%.  Three factors drive this trend. First, ​​digital convenience​​—e-books are portable and instantly accessible. Second, ​​environmental concerns​​—many readers prefer paperless options to reduce deforestation. Third, ​​pricing​​—e-books are often cheaper due to lower production costs.  Looking ahead, print books may stabilize as niche markets (e.g., collectors, children’s books) persist. However, e-books will likely dominate, especially with advancements in e-ink technology and interactive features. Ultimately, this shift reflects broader societal adaptation to the digital age.', '\n描述数据​​：用对比词汇（dominated, plummeted, surged）。\n​​分析原因​​：分点论述，结合社会背景。\n​​预测趋势​​：避免绝对化（may, likely）。\n', 1, NULL, -5);
INSERT INTO `wrong_question` (`id`, `user_id`, `question_id`, `category`, `type`, `question_content`, `user_answer`, `correct_answer`, `analysis`, `wrong_count`, `notes`, `score_impact`) VALUES (10, 10, 24, 'CET6', 'reading', 'The rapid advancement of artificial intelligence (AI) has triggered widespread concern about its impact on employment. While some economists predict massive job displacement, others argue that AI will create new roles that require advanced skills. A 2023 report by the World Economic Forum estimates that by 2025, AI could eliminate 85 million jobs but generate 97 million new ones, resulting in a net gain. However, the transition may be painful for low-skilled workers, as AI tends to automate routine tasks first. Governments and educational institutions must prioritize reskilling programs to mitigate unemployment risks.\n\n​​Questions:​​\n\nWhat is the main concern about AI’s impact on employment?\nA) It will reduce wages.\nB) It will replace human workers.\nC) It will increase job competition.\nD) It will lower productivity.\nAccording to the WEF report, what is the expected net effect of AI on jobs by 2025?\nA) A loss of 85 million jobs.\nB) A gain of 97 million jobs.\nC) A net increase of 12 million jobs.\nD) No significant change.\nWhich group is most vulnerable to AI-driven job losses?\nA) High-skilled professionals.\nB) Low-skilled workers.\nC) Government employees.\nD) Entrepreneurs.\nWhat does the author suggest to address AI-related unemployment?\nA) Reducing AI development.\nB) Implementing reskilling programs.\nC) Encouraging early retirement.\nD) Increasing manual labor jobs.\nThe word \"mitigate\" (last sentence) is closest in meaning to ______.\nA) eliminate\nB) worsen\nC) reduce\nD) ignore', '_C___', 'BCBBC', '​​\nB​​（AI 取代人力）\n​​C​​（净增 1200 万岗位）\n​​B​​（低技能工人最受影响）\n​​B​​（再培训计划）\n​​C​​（mitigate = reduce）', 2, NULL, -5);
INSERT INTO `wrong_question` (`id`, `user_id`, `question_id`, `category`, `type`, `question_content`, `user_answer`, `correct_answer`, `analysis`, `wrong_count`, `notes`, `score_impact`) VALUES (11, 10, 21, 'CET4', 'translation', 'Directions:​​ Translate the following Chinese sentences into English.\n中国茶文化历史悠久，可追溯至数千年前。茶不仅是一种饮品，更是中国传统礼仪的重要组成部分。无论是家庭聚会还是商务谈判，茶都扮演着关键角色。近年来，随着健康生活方式的普及，绿茶因其抗氧化功效而备受推崇。', '1', '​​ Chinese tea culture has a long history, dating back thousands of years. Tea is not merely a beverage but also a vital part of traditional Chinese etiquette. Whether at family gatherings or business negotiations, tea plays a pivotal role. In recent years, with the popularity of healthy lifestyles, green tea has been highly valued for its antioxidant properties.', '\"追溯至\"译为\"dating back\"（固定搭配）\n\"重要组成部分\"用\"vital part\"（避免直译\"important component\"）\n\"扮演关键角色\"译为\"plays a pivotal role\"（比\"important\"更地道）\n\"抗氧化功效\"需用专业词汇\"antioxidant properties\"', 3, NULL, -5);
INSERT INTO `wrong_question` (`id`, `user_id`, `question_id`, `category`, `type`, `question_content`, `user_answer`, `correct_answer`, `analysis`, `wrong_count`, `notes`, `score_impact`) VALUES (12, 10, 32, 'CET4', 'translation', 'A few years ago, I was stuck in a cycle of procrastination. I wanted to write a book, get fit, and learn a new language—but I kept waiting for the ‘perfect moment.’ Then I discovered something revolutionary: ​​tiny habits​​. Not grand resolutions, but small, consistent actions. Today, I’ve published that book, run marathons, and even speak Spanish—all because of habits so small they seemed trivial at first.\"', '1', '几年前，我深陷拖延症的泥潭。我想写一本书、健身、学一门新语言——却一直在等待“完美时机”。直到后来，我发现了某种颠覆性的方法：微习惯。不是宏大的目标，而是微小却持之以恒的行动。如今，我出版了那本书、跑完了马拉松，甚至能说一口流利的西班牙语——一切都源于那些起初看似微不足道的习惯。    （注：根据 TED 演讲风格，翻译时保留了口语化的感染力，如“泥潭”“颠覆性”等比喻，同时将“tiny habits”译为“微习惯”以贴合中文习惯说法。关键句如“不是...而是...”的对比结构也还原了原文的节奏感。）', 'easy', 3, NULL, -5);
INSERT INTO `wrong_question` (`id`, `user_id`, `question_id`, `category`, `type`, `question_content`, `user_answer`, `correct_answer`, `analysis`, `wrong_count`, `notes`, `score_impact`) VALUES (13, 10, 22, 'CET4', 'writing', 'Directions:​​ Write an essay on the topic: \"Should College Students Take a Gap Year?\" \nYou should write at least 120 words but no more than 180 words.', '1', 'The idea of taking a gap year after high school is increasingly popular, but its value for college students remains debated. Proponents argue that a gap year provides opportunities to gain work experience, travel, or volunteer, which can enhance personal growth and clarify career goals. For example, students interning abroad may develop cross-cultural skills.  However, opponents worry about academic discontinuity and financial costs. A year off might lead to lost momentum in studies, and unpaid internships could burden families.  In my view, a well-planned gap year is beneficial. Universities should offer structured programs to ensure students use the time productively. Ultimately, the decision depends on individual circumstances and goals.', '​​首段​​：引入话题+正方观点（个人成长）\n​​次段​​：反方观点（学业中断、经济压力）\n​​尾段​​：个人立场+建议（学校提供支持）\n\n​​加分点：​​\n举例论证（\"interning abroad\"）\n平衡讨论（\"However\"衔接对立观点）\n提出解决方案（\"structured programs\"）', 23, NULL, -5);
INSERT INTO `wrong_question` (`id`, `user_id`, `question_id`, `category`, `type`, `question_content`, `user_answer`, `correct_answer`, `analysis`, `wrong_count`, `notes`, `score_impact`) VALUES (14, 2, 22, 'CET4', 'writing', 'Directions:​​ Write an essay on the topic: \"Should College Students Take a Gap Year?\" \nYou should write at least 120 words but no more than 180 words.', '', 'The idea of taking a gap year after high school is increasingly popular, but its value for college students remains debated. Proponents argue that a gap year provides opportunities to gain work experience, travel, or volunteer, which can enhance personal growth and clarify career goals. For example, students interning abroad may develop cross-cultural skills.  However, opponents worry about academic discontinuity and financial costs. A year off might lead to lost momentum in studies, and unpaid internships could burden families.  In my view, a well-planned gap year is beneficial. Universities should offer structured programs to ensure students use the time productively. Ultimately, the decision depends on individual circumstances and goals.', '​​首段​​：引入话题+正方观点（个人成长）\n​​次段​​：反方观点（学业中断、经济压力）\n​​尾段​​：个人立场+建议（学校提供支持）\n\n​​加分点：​​\n举例论证（\"interning abroad\"）\n平衡讨论（\"However\"衔接对立观点）\n提出解决方案（\"structured programs\"）', 1, NULL, -5);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
